IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'Genre')
	BEGIN
		DROP  Table Genre
	END
GO

CREATE TABLE Genre
(
   Id int IDENTITY PRIMARY KEY,
   [Name] varchar(100) NOT NULL,
   Description varchar(255) NULL,
   LibraryId int NULL REFERENCES Library(Id)
)
GO

